Overview
Brought to you by YData
Dataset statistics
| Number of variables | 17 |
|---|---|
| Number of observations | 3255 |
| Missing cells | 3698 |
| Missing cells (%) | 6.7% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 2.1 MiB |
| Average record size in memory | 663.9 B |
Variable types
| Numeric | 7 |
|---|---|
| DateTime | 2 |
| Categorical | 6 |
| Text | 2 |
Bias Motive Description is highly overall correlated with Offense Category | High correlation |
Complaint Precinct Code is highly overall correlated with County and 1 other fields | High correlation |
Complaint Year Number is highly overall correlated with Full Complaint ID | High correlation |
County is highly overall correlated with Complaint Precinct Code and 1 other fields | High correlation |
Full Complaint ID is highly overall correlated with Complaint Year Number | High correlation |
Law Code Category Description is highly overall correlated with Offense Description | High correlation |
Offense Category is highly overall correlated with Bias Motive Description | High correlation |
Offense Description is highly overall correlated with Law Code Category Description | High correlation |
Patrol Borough Name is highly overall correlated with Complaint Precinct Code and 1 other fields | High correlation |
Unnamed: 0 is highly overall correlated with Unnamed: 0.1 and 1 other fields | High correlation |
Unnamed: 0.1 is highly overall correlated with Unnamed: 0 and 1 other fields | High correlation |
Unnamed: 0.2 is highly overall correlated with Unnamed: 0 and 1 other fields | High correlation |
Arrest Date has 1849 (56.8%) missing values | Missing |
Arrest Id has 1849 (56.8%) missing values | Missing |
Unnamed: 0.2 is uniformly distributed | Uniform |
Unnamed: 0.1 is uniformly distributed | Uniform |
Unnamed: 0 is uniformly distributed | Uniform |
Unnamed: 0.2 has unique values | Unique |
Unnamed: 0.1 has unique values | Unique |
Unnamed: 0 has unique values | Unique |
Reproduction
| Analysis started | 2025-02-21 20:47:46.723578 |
|---|---|
| Analysis finished | 2025-02-21 20:47:51.051558 |
| Duration | 4.33 seconds |
| Software version | ydata-profiling vv4.12.2 |
| Download configuration | config.json |
Variables
Unnamed: 0.2
Real number (ℝ)
High correlation  Uniform  Unique 
| Distinct | 3255 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1627 |
| Minimum | 0 |
|---|---|
| Maximum | 3254 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 25.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 162.7 |
| Q1 | 813.5 |
| median | 1627 |
| Q3 | 2440.5 |
| 95-th percentile | 3091.3 |
| Maximum | 3254 |
| Range | 3254 |
| Interquartile range (IQR) | 1627 |
Descriptive statistics
| Standard deviation | 939.78189 |
|---|---|
| Coefficient of variation (CV) | 0.5776164 |
| Kurtosis | -1.2 |
| Mean | 1627 |
| Median Absolute Deviation (MAD) | 814 |
| Skewness | 0 |
| Sum | 5295885 |
| Variance | 883190 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 3254 | 1 | < 0.1% |
| 0 | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
| 2 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
| 4 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 3238 | 1 | < 0.1% |
| 3237 | 1 | < 0.1% |
| 3236 | 1 | < 0.1% |
| Other values (3245) | 3245 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 3254 | 1 | |
| 3253 | 1 | |
| 3252 | 1 | |
| 3251 | 1 | |
| 3250 | 1 | |
| 3249 | 1 | |
| 3248 | 1 | |
| 3247 | 1 | |
| 3246 | 1 | |
| 3245 | 1 |
Unnamed: 0.1
Real number (ℝ)
High correlation  Uniform  Unique 
| Distinct | 3255 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1627 |
| Minimum | 0 |
|---|---|
| Maximum | 3254 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 25.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 162.7 |
| Q1 | 813.5 |
| median | 1627 |
| Q3 | 2440.5 |
| 95-th percentile | 3091.3 |
| Maximum | 3254 |
| Range | 3254 |
| Interquartile range (IQR) | 1627 |
Descriptive statistics
| Standard deviation | 939.78189 |
|---|---|
| Coefficient of variation (CV) | 0.5776164 |
| Kurtosis | -1.2 |
| Mean | 1627 |
| Median Absolute Deviation (MAD) | 814 |
| Skewness | 0 |
| Sum | 5295885 |
| Variance | 883190 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 3254 | 1 | < 0.1% |
| 0 | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
| 2 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
| 4 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 3238 | 1 | < 0.1% |
| 3237 | 1 | < 0.1% |
| 3236 | 1 | < 0.1% |
| Other values (3245) | 3245 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 3254 | 1 | |
| 3253 | 1 | |
| 3252 | 1 | |
| 3251 | 1 | |
| 3250 | 1 | |
| 3249 | 1 | |
| 3248 | 1 | |
| 3247 | 1 | |
| 3246 | 1 | |
| 3245 | 1 |
Unnamed: 0
Real number (ℝ)
High correlation  Uniform  Unique 
| Distinct | 3255 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1627 |
| Minimum | 0 |
|---|---|
| Maximum | 3254 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 25.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 162.7 |
| Q1 | 813.5 |
| median | 1627 |
| Q3 | 2440.5 |
| 95-th percentile | 3091.3 |
| Maximum | 3254 |
| Range | 3254 |
| Interquartile range (IQR) | 1627 |
Descriptive statistics
| Standard deviation | 939.78189 |
|---|---|
| Coefficient of variation (CV) | 0.5776164 |
| Kurtosis | -1.2 |
| Mean | 1627 |
| Median Absolute Deviation (MAD) | 814 |
| Skewness | 0 |
| Sum | 5295885 |
| Variance | 883190 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 3254 | 1 | < 0.1% |
| 0 | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
| 2 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
| 4 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 3238 | 1 | < 0.1% |
| 3237 | 1 | < 0.1% |
| 3236 | 1 | < 0.1% |
| Other values (3245) | 3245 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 3254 | 1 | |
| 3253 | 1 | |
| 3252 | 1 | |
| 3251 | 1 | |
| 3250 | 1 | |
| 3249 | 1 | |
| 3248 | 1 | |
| 3247 | 1 | |
| 3246 | 1 | |
| 3245 | 1 |
Full Complaint ID
Real number (ℝ)
High correlation 
| Distinct | 2991 |
|---|---|
| Distinct (%) | 91.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.0218455 × 1014 |
| Minimum | 2.0190011 × 1014 |
|---|---|
| Maximum | 2.0241231 × 1014 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 25.6 KiB |
Quantile statistics
| Minimum | 2.0190011 × 1014 |
|---|---|
| 5-th percentile | 2.0190481 × 1014 |
| Q1 | 2.0210131 × 1014 |
| median | 2.0220611 × 1014 |
| Q3 | 2.0230766 × 1014 |
| 95-th percentile | 2.0240781 × 1014 |
| Maximum | 2.0241231 × 1014 |
| Range | 5.1220021 × 1011 |
| Interquartile range (IQR) | 2.0635001 × 1011 |
Descriptive statistics
| Standard deviation | 1.608058 × 1011 |
|---|---|
| Coefficient of variation (CV) | 0.00079534167 |
| Kurtosis | -0.97355218 |
| Mean | 2.0218455 × 1014 |
| Median Absolute Deviation (MAD) | 1.0370029 × 1011 |
| Skewness | -0.33742337 |
| Sum | 6.5811071 × 1017 |
| Variance | 2.5858504 × 1022 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2.023109127 × 1014 | 11 | 0.3% |
| 2.021018123 × 1014 | 9 | 0.3% |
| 2.022090127 × 1014 | 6 | 0.2% |
| 2.023018123 × 1014 | 5 | 0.2% |
| 2.023010125 × 1014 | 5 | 0.2% |
| 2.02207513 × 1014 | 5 | 0.2% |
| 2.023060123 × 1014 | 4 | 0.1% |
| 2.019066126 × 1014 | 4 | 0.1% |
| 2.022115128 × 1014 | 4 | 0.1% |
| 2.020044124 × 1014 | 4 | 0.1% |
| Other values (2981) | 3198 |
| Value | Count | Frequency (%) |
| 2.019001121 × 1014 | 1 | |
| 2.019001121 × 1014 | 1 | |
| 2.019001122 × 1014 | 1 | |
| 2.019001122 × 1014 | 1 | |
| 2.019001122 × 1014 | 1 | |
| 2.019001123 × 1014 | 1 | |
| 2.019001124 × 1014 | 1 | |
| 2.019001124 × 1014 | 1 | |
| 2.019001125 × 1014 | 1 | |
| 2.019001126 × 1014 | 1 |
| Value | Count | Frequency (%) |
| 2.024123123 × 1014 | 1 | |
| 2.024123123 × 1014 | 1 | |
| 2.024123122 × 1014 | 1 | |
| 2.024122126 × 1014 | 1 | |
| 2.024122124 × 1014 | 1 | |
| 2.024122124 × 1014 | 1 | |
| 2.024122123 × 1014 | 1 | |
| 2.024122122 × 1014 | 1 | |
| 2.024121127 × 1014 | 1 | |
| 2.024121125 × 1014 | 1 |
Complaint Year Number
Real number (ℝ)
High correlation 
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2021.7868 |
| Minimum | 2019 |
|---|---|
| Maximum | 2024 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 25.6 KiB |
Quantile statistics
| Minimum | 2019 |
|---|---|
| 5-th percentile | 2019 |
| Q1 | 2021 |
| median | 2022 |
| Q3 | 2023 |
| 95-th percentile | 2024 |
| Maximum | 2024 |
| Range | 5 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.6086001 |
|---|---|
| Coefficient of variation (CV) | 0.00079563291 |
| Kurtosis | -0.97190774 |
| Mean | 2021.7868 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.33944202 |
| Sum | 6580916 |
| Variance | 2.5875943 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2023 | 755 | |
| 2022 | 672 | |
| 2021 | 578 | |
| 2024 | 519 | |
| 2019 | 447 | |
| 2020 | 284 | 8.7% |
| Value | Count | Frequency (%) |
| 2019 | 447 | |
| 2020 | 284 | 8.7% |
| 2021 | 578 | |
| 2022 | 672 | |
| 2023 | 755 | |
| 2024 | 519 |
| Value | Count | Frequency (%) |
| 2024 | 519 | |
| 2023 | 755 | |
| 2022 | 672 | |
| 2021 | 578 | |
| 2020 | 284 | 8.7% |
| 2019 | 447 |
Month Number
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.3004608 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 25.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 6 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.2917989 |
|---|---|
| Coefficient of variation (CV) | 0.52246955 |
| Kurtosis | -1.1210351 |
| Mean | 6.3004608 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.1150436 |
| Sum | 20508 |
| Variance | 10.83594 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 349 | |
| 3 | 344 | |
| 6 | 324 | |
| 4 | 275 | |
| 9 | 269 | |
| 7 | 269 | |
| 10 | 265 | |
| 2 | 253 | |
| 8 | 238 | |
| 11 | 230 | |
| Other values (2) | 439 |
| Value | Count | Frequency (%) |
| 1 | 225 | |
| 2 | 253 | |
| 3 | 344 | |
| 4 | 275 | |
| 5 | 349 | |
| 6 | 324 | |
| 7 | 269 | |
| 8 | 238 | |
| 9 | 269 | |
| 10 | 265 |
| Value | Count | Frequency (%) |
| 12 | 214 | |
| 11 | 230 | |
| 10 | 265 | |
| 9 | 269 | |
| 8 | 238 | |
| 7 | 269 | |
| 6 | 324 | |
| 5 | 349 | |
| 4 | 275 | |
| 3 | 344 |
| Distinct | 1447 |
|---|---|
| Distinct (%) | 44.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 25.6 KiB |
| Minimum | 2019-01-01 00:00:00 |
|---|---|
| Maximum | 2024-09-30 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Complaint Precinct Code
Real number (ℝ)
High correlation 
| Distinct | 77 |
|---|---|
| Distinct (%) | 2.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 58.571736 |
| Minimum | 1 |
|---|---|
| Maximum | 123 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 25.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 19 |
| median | 63 |
| Q3 | 90 |
| 95-th percentile | 115 |
| Maximum | 123 |
| Range | 122 |
| Interquartile range (IQR) | 71 |
Descriptive statistics
| Standard deviation | 38.014809 |
|---|---|
| Coefficient of variation (CV) | 0.64902992 |
| Kurtosis | -1.3738998 |
| Mean | 58.571736 |
| Median Absolute Deviation (MAD) | 39 |
| Skewness | 0.04320368 |
| Sum | 190651 |
| Variance | 1445.1257 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 90 | 134 | 4.1% |
| 14 | 123 | 3.8% |
| 19 | 115 | 3.5% |
| 18 | 95 | 2.9% |
| 61 | 95 | 2.9% |
| 70 | 93 | 2.9% |
| 71 | 88 | 2.7% |
| 66 | 87 | 2.7% |
| 13 | 86 | 2.6% |
| 1 | 81 | 2.5% |
| Other values (67) | 2258 |
| Value | Count | Frequency (%) |
| 1 | 81 | |
| 5 | 65 | |
| 6 | 71 | |
| 7 | 62 | |
| 9 | 36 | 1.1% |
| 10 | 80 | |
| 13 | 86 | |
| 14 | 123 | |
| 17 | 50 | |
| 18 | 95 |
| Value | Count | Frequency (%) |
| 123 | 16 | 0.5% |
| 122 | 37 | |
| 121 | 35 | |
| 120 | 34 | |
| 115 | 49 | |
| 114 | 62 | |
| 113 | 12 | 0.4% |
| 112 | 62 | |
| 111 | 26 | |
| 110 | 46 |
Patrol Borough Name
Categorical
High correlation 
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 226.2 KiB |
| PATROL BORO MAN SOUTH | |
|---|---|
| PATROL BORO BKLYN SOUTH | |
| PATROL BORO BKLYN NORTH | |
| PATROL BORO MAN NORTH | |
| PATROL BORO QUEENS NORTH | |
| Other values (3) |
Length
| Max length | 25 |
|---|---|
| Median length | 24 |
| Mean length | 22.135791 |
| Min length | 17 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PATROL BORO BRONX |
|---|---|
| 2nd row | PATROL BORO BRONX |
| 3rd row | PATROL BORO BRONX |
| 4th row | PATROL BORO BKLYN SOUTH |
| 5th row | PATROL BORO BKLYN SOUTH |
Common Values
| Value | Count | Frequency (%) |
| PATROL BORO MAN SOUTH | 749 | |
| PATROL BORO BKLYN SOUTH | 639 | |
| PATROL BORO BKLYN NORTH | 491 | |
| PATROL BORO MAN NORTH | 471 | |
| PATROL BORO QUEENS NORTH | 371 | |
| PATROL BORO QUEENS SOUTH | 212 | 6.5% |
| PATROL BORO BRONX | 200 | 6.1% |
| PATROL BORO STATEN ISLAND | 122 | 3.7% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| patrol | 3255 | |
| boro | 3255 | |
| south | 1600 | |
| north | 1333 | |
| man | 1220 | 9.5% |
| bklyn | 1130 | 8.8% |
| queens | 583 | 4.5% |
| bronx | 200 | 1.6% |
| staten | 122 | 1.0% |
| island | 122 | 1.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 12898 | |
| 9565 | ||
| R | 8043 | |
| T | 6432 | |
| A | 4719 | 6.5% |
| N | 4710 | 6.5% |
| B | 4585 | 6.4% |
| L | 4507 | 6.3% |
| P | 3255 | 4.5% |
| H | 2933 | 4.1% |
| Other values (10) | 10405 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 72052 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| O | 12898 | |
| 9565 | ||
| R | 8043 | |
| T | 6432 | |
| A | 4719 | 6.5% |
| N | 4710 | 6.5% |
| B | 4585 | 6.4% |
| L | 4507 | 6.3% |
| P | 3255 | 4.5% |
| H | 2933 | 4.1% |
| Other values (10) | 10405 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 72052 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| O | 12898 | |
| 9565 | ||
| R | 8043 | |
| T | 6432 | |
| A | 4719 | 6.5% |
| N | 4710 | 6.5% |
| B | 4585 | 6.4% |
| L | 4507 | 6.3% |
| P | 3255 | 4.5% |
| H | 2933 | 4.1% |
| Other values (10) | 10405 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 72052 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| O | 12898 | |
| 9565 | ||
| R | 8043 | |
| T | 6432 | |
| A | 4719 | 6.5% |
| N | 4710 | 6.5% |
| B | 4585 | 6.4% |
| L | 4507 | 6.3% |
| P | 3255 | 4.5% |
| H | 2933 | 4.1% |
| Other values (10) | 10405 |
County
Categorical
High correlation 
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 176.3 KiB |
| NEW YORK | |
|---|---|
| KINGS | |
| QUEENS | |
| BRONX | |
| RICHMOND | 122 |
Length
| Max length | 8 |
|---|---|
| Median length | 6 |
| Mean length | 6.4159754 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BRONX |
|---|---|
| 2nd row | BRONX |
| 3rd row | BRONX |
| 4th row | KINGS |
| 5th row | KINGS |
Common Values
| Value | Count | Frequency (%) |
| NEW YORK | 1220 | |
| KINGS | 1130 | |
| QUEENS | 583 | |
| BRONX | 200 | 6.1% |
| RICHMOND | 122 | 3.7% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| new | 1220 | |
| york | 1220 | |
| kings | 1130 | |
| queens | 583 | |
| bronx | 200 | 4.5% |
| richmond | 122 | 2.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 3255 | |
| E | 2386 | |
| K | 2350 | |
| S | 1713 | |
| R | 1542 | |
| O | 1542 | |
| I | 1252 | 6.0% |
| W | 1220 | 5.8% |
| Y | 1220 | 5.8% |
| 1220 | 5.8% | |
| Other values (9) | 3184 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 20884 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| N | 3255 | |
| E | 2386 | |
| K | 2350 | |
| S | 1713 | |
| R | 1542 | |
| O | 1542 | |
| I | 1252 | 6.0% |
| W | 1220 | 5.8% |
| Y | 1220 | 5.8% |
| 1220 | 5.8% | |
| Other values (9) | 3184 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 20884 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| N | 3255 | |
| E | 2386 | |
| K | 2350 | |
| S | 1713 | |
| R | 1542 | |
| O | 1542 | |
| I | 1252 | 6.0% |
| W | 1220 | 5.8% |
| Y | 1220 | 5.8% |
| 1220 | 5.8% | |
| Other values (9) | 3184 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 20884 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| N | 3255 | |
| E | 2386 | |
| K | 2350 | |
| S | 1713 | |
| R | 1542 | |
| O | 1542 | |
| I | 1252 | 6.0% |
| W | 1220 | 5.8% |
| Y | 1220 | 5.8% |
| 1220 | 5.8% | |
| Other values (9) | 3184 |
Law Code Category Description
Categorical
High correlation 
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 182.9 KiB |
| FELONY | |
|---|---|
| MISDEMEANOR | |
| VIOLATION | 23 |
| INVESTIGATION | 2 |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 8.5016897 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | FELONY |
|---|---|
| 2nd row | FELONY |
| 3rd row | FELONY |
| 4th row | FELONY |
| 5th row | MISDEMEANOR |
Common Values
| Value | Count | Frequency (%) |
| FELONY | 1618 | |
| MISDEMEANOR | 1612 | |
| VIOLATION | 23 | 0.7% |
| INVESTIGATION | 2 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| felony | 1618 | |
| misdemeanor | 1612 | |
| violation | 23 | 0.7% |
| investigation | 2 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 4844 | |
| O | 3278 | |
| N | 3257 | |
| M | 3224 | |
| I | 1664 | 6.0% |
| L | 1641 | 5.9% |
| A | 1637 | 5.9% |
| Y | 1618 | 5.8% |
| F | 1618 | 5.8% |
| S | 1614 | 5.8% |
| Other values (5) | 3278 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 27673 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| E | 4844 | |
| O | 3278 | |
| N | 3257 | |
| M | 3224 | |
| I | 1664 | 6.0% |
| L | 1641 | 5.9% |
| A | 1637 | 5.9% |
| Y | 1618 | 5.8% |
| F | 1618 | 5.8% |
| S | 1614 | 5.8% |
| Other values (5) | 3278 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 27673 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| E | 4844 | |
| O | 3278 | |
| N | 3257 | |
| M | 3224 | |
| I | 1664 | 6.0% |
| L | 1641 | 5.9% |
| A | 1637 | 5.9% |
| Y | 1618 | 5.8% |
| F | 1618 | 5.8% |
| S | 1614 | 5.8% |
| Other values (5) | 3278 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 27673 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| E | 4844 | |
| O | 3278 | |
| N | 3257 | |
| M | 3224 | |
| I | 1664 | 6.0% |
| L | 1641 | 5.9% |
| A | 1637 | 5.9% |
| Y | 1618 | 5.8% |
| F | 1618 | 5.8% |
| S | 1614 | 5.8% |
| Other values (5) | 3278 |
Offense Description
Categorical
High correlation 
| Distinct | 23 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 233.0 KiB |
| MISCELLANEOUS PENAL LAW | |
|---|---|
| CRIMINAL MISCHIEF & RELATED OF | |
| ASSAULT 3 & RELATED OFFENSES | |
| OFF. AGNST PUB ORD SENSBLTY & | |
| FELONY ASSAULT | |
| Other values (18) |
Length
| Max length | 30 |
|---|---|
| Median length | 28 |
| Mean length | 24.245776 |
| Min length | 4 |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | BURGLARY |
|---|---|
| 2nd row | MISCELLANEOUS PENAL LAW |
| 3rd row | FELONY ASSAULT |
| 4th row | MURDER & NON-NEGL. MANSLAUGHTE |
| 5th row | OFF. AGNST PUB ORD SENSBLTY & |
Common Values
| Value | Count | Frequency (%) |
| MISCELLANEOUS PENAL LAW | 836 | |
| CRIMINAL MISCHIEF & RELATED OF | 670 | |
| ASSAULT 3 & RELATED OFFENSES | 654 | |
| OFF. AGNST PUB ORD SENSBLTY & | 446 | |
| FELONY ASSAULT | 394 | |
| ROBBERY | 108 | 3.3% |
| GRAND LARCENY | 43 | 1.3% |
| HARRASSMENT 2 | 23 | 0.7% |
| PETIT LARCENY | 20 | 0.6% |
| SEX CRIMES | 15 | 0.5% |
| Other values (13) | 46 | 1.4% |
Length
| Value | Count | Frequency (%) |
| 1778 | ||
| related | 1325 | 10.2% |
| assault | 1048 | 8.1% |
| penal | 836 | 6.4% |
| miscellaneous | 836 | 6.4% |
| law | 836 | 6.4% |
| criminal | 672 | 5.2% |
| mischief | 670 | 5.2% |
| of | 670 | 5.2% |
| offenses | 661 | 5.1% |
| Other values (35) | 3668 |
Most occurring characters
| Value | Count | Frequency (%) |
| 9745 | ||
| E | 8287 | |
| L | 7331 | 9.3% |
| A | 7267 | 9.2% |
| S | 7223 | 9.2% |
| N | 4490 | 5.7% |
| F | 3951 | 5.0% |
| O | 3594 | 4.6% |
| I | 3587 | 4.5% |
| T | 3355 | 4.3% |
| Other values (21) | 20090 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 78920 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 9745 | ||
| E | 8287 | |
| L | 7331 | 9.3% |
| A | 7267 | 9.2% |
| S | 7223 | 9.2% |
| N | 4490 | 5.7% |
| F | 3951 | 5.0% |
| O | 3594 | 4.6% |
| I | 3587 | 4.5% |
| T | 3355 | 4.3% |
| Other values (21) | 20090 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 78920 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 9745 | ||
| E | 8287 | |
| L | 7331 | 9.3% |
| A | 7267 | 9.2% |
| S | 7223 | 9.2% |
| N | 4490 | 5.7% |
| F | 3951 | 5.0% |
| O | 3594 | 4.6% |
| I | 3587 | 4.5% |
| T | 3355 | 4.3% |
| Other values (21) | 20090 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 78920 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 9745 | ||
| E | 8287 | |
| L | 7331 | 9.3% |
| A | 7267 | 9.2% |
| S | 7223 | 9.2% |
| N | 4490 | 5.7% |
| F | 3951 | 5.0% |
| O | 3594 | 4.6% |
| I | 3587 | 4.5% |
| T | 3355 | 4.3% |
| Other values (21) | 20090 |
| Distinct | 82 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 227.2 KiB |
Length
| Max length | 60 |
|---|---|
| Median length | 54 |
| Mean length | 22.437481 |
| Min length | 6 |
Unique
| Unique | 30 ? |
|---|---|
| Unique (%) | 0.9% |
Sample
| 1st row | BURGLARY,UNCLASSIFIED,NIGHT |
|---|---|
| 2nd row | AGGRAVATED HARASSMENT 1 |
| 3rd row | ASSAULT 2,1,UNCLASSIFIED |
| 4th row | MURDER,UNCLASSIFIED |
| 5th row | AGGRAVATED HARASSMENT 2 |
| Value | Count | Frequency (%) |
| aggravated | 1207 | |
| harassment | 1207 | |
| assault | 930 | |
| 1 | 770 | 8.4% |
| 3 | 635 | 6.9% |
| criminal | 566 | 6.2% |
| 2 | 538 | 5.9% |
| mischief | 387 | 4.2% |
| 2,1,unclassified | 383 | 4.2% |
| 4th | 334 | 3.6% |
| Other values (142) | 2226 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 10249 | |
| S | 6614 | 9.1% |
| 6258 | 8.6% | |
| I | 4858 | 6.7% |
| E | 4713 | 6.5% |
| T | 4504 | 6.2% |
| R | 4414 | 6.0% |
| N | 3571 | 4.9% |
| G | 3072 | 4.2% |
| M | 2890 | 4.0% |
| Other values (28) | 21891 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 73034 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 10249 | |
| S | 6614 | 9.1% |
| 6258 | 8.6% | |
| I | 4858 | 6.7% |
| E | 4713 | 6.5% |
| T | 4504 | 6.2% |
| R | 4414 | 6.0% |
| N | 3571 | 4.9% |
| G | 3072 | 4.2% |
| M | 2890 | 4.0% |
| Other values (28) | 21891 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 73034 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 10249 | |
| S | 6614 | 9.1% |
| 6258 | 8.6% | |
| I | 4858 | 6.7% |
| E | 4713 | 6.5% |
| T | 4504 | 6.2% |
| R | 4414 | 6.0% |
| N | 3571 | 4.9% |
| G | 3072 | 4.2% |
| M | 2890 | 4.0% |
| Other values (28) | 21891 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 73034 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 10249 | |
| S | 6614 | 9.1% |
| 6258 | 8.6% | |
| I | 4858 | 6.7% |
| E | 4713 | 6.5% |
| T | 4504 | 6.2% |
| R | 4414 | 6.0% |
| N | 3571 | 4.9% |
| G | 3072 | 4.2% |
| M | 2890 | 4.0% |
| Other values (28) | 21891 |
Bias Motive Description
Categorical
High correlation 
| Distinct | 28 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 199.4 KiB |
| ANTI-JEWISH | |
|---|---|
| ANTI-MALE HOMOSEXUAL (GAY) | |
| ANTI-ASIAN | |
| ANTI-BLACK | |
| ANTI-OTHER ETHNICITY | 133 |
| Other values (23) |
Length
| Max length | 33 |
|---|---|
| Median length | 11 |
| Mean length | 13.67404 |
| Min length | 9 |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | ANTI-JEWISH |
|---|---|
| 2nd row | ANTI-JEWISH |
| 3rd row | ANTI-MALE HOMOSEXUAL (GAY) |
| 4th row | ANTI-ASIAN |
| 5th row | ANTI-JEWISH |
Common Values
| Value | Count | Frequency (%) |
| ANTI-JEWISH | 1504 | |
| ANTI-MALE HOMOSEXUAL (GAY) | 420 | 12.9% |
| ANTI-ASIAN | 355 | 10.9% |
| ANTI-BLACK | 257 | 7.9% |
| ANTI-OTHER ETHNICITY | 133 | 4.1% |
| ANTI-MUSLIM | 121 | 3.7% |
| ANTI-WHITE | 110 | 3.4% |
| ANTI-TRANSGENDER | 84 | 2.6% |
| ANTI-HISPANIC | 77 | 2.4% |
| ANTI-CATHOLIC | 57 | 1.8% |
| Other values (18) | 137 | 4.2% |
Length
| Value | Count | Frequency (%) |
| anti-jewish | 1504 | |
| homosexual | 457 | 10.5% |
| anti-male | 421 | 9.7% |
| gay | 420 | 9.6% |
| anti-asian | 355 | 8.1% |
| anti-black | 257 | 5.9% |
| anti-other | 139 | 3.2% |
| ethnicity | 133 | 3.1% |
| anti-muslim | 121 | 2.8% |
| anti-white | 110 | 2.5% |
| Other values (32) | 439 | 10.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| I | 5932 | |
| A | 5876 | |
| N | 4096 | |
| T | 3954 | 8.9% |
| - | 3266 | 7.3% |
| E | 3154 | 7.1% |
| S | 2672 | 6.0% |
| H | 2505 | 5.6% |
| W | 1616 | 3.6% |
| J | 1506 | 3.4% |
| Other values (20) | 9932 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 44509 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| I | 5932 | |
| A | 5876 | |
| N | 4096 | |
| T | 3954 | 8.9% |
| - | 3266 | 7.3% |
| E | 3154 | 7.1% |
| S | 2672 | 6.0% |
| H | 2505 | 5.6% |
| W | 1616 | 3.6% |
| J | 1506 | 3.4% |
| Other values (20) | 9932 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 44509 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| I | 5932 | |
| A | 5876 | |
| N | 4096 | |
| T | 3954 | 8.9% |
| - | 3266 | 7.3% |
| E | 3154 | 7.1% |
| S | 2672 | 6.0% |
| H | 2505 | 5.6% |
| W | 1616 | 3.6% |
| J | 1506 | 3.4% |
| Other values (20) | 9932 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 44509 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| I | 5932 | |
| A | 5876 | |
| N | 4096 | |
| T | 3954 | 8.9% |
| - | 3266 | 7.3% |
| E | 3154 | 7.1% |
| S | 2672 | 6.0% |
| H | 2505 | 5.6% |
| W | 1616 | 3.6% |
| J | 1506 | 3.4% |
| Other values (20) | 9932 |
Offense Category
Categorical
High correlation 
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 224.5 KiB |
| Religion/Religious Practice | |
|---|---|
| Race/Color | |
| Sexual Orientation | |
| Ethnicity/National Origin/Ancestry | |
| Gender | 119 |
| Other values (3) | 10 |
Length
| Max length | 34 |
|---|---|
| Median length | 27 |
| Mean length | 21.581874 |
| Min length | 3 |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Religion/Religious Practice |
|---|---|
| 2nd row | Religion/Religious Practice |
| 3rd row | Sexual Orientation |
| 4th row | Race/Color |
| 5th row | Religion/Religious Practice |
Common Values
| Value | Count | Frequency (%) |
| Religion/Religious Practice | 1718 | |
| Race/Color | 724 | |
| Sexual Orientation | 466 | 14.3% |
| Ethnicity/National Origin/Ancestry | 218 | 6.7% |
| Gender | 119 | 3.7% |
| Unclassified | 8 | 0.2% |
| Disability | 1 | < 0.1% |
| Age | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| religion/religious | 1718 | |
| practice | 1718 | |
| race/color | 724 | |
| sexual | 466 | 8.2% |
| orientation | 466 | 8.2% |
| ethnicity/national | 218 | 3.9% |
| origin/ancestry | 218 | 3.9% |
| gender | 119 | 2.1% |
| unclassified | 8 | 0.1% |
| disability | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 10631 | |
| e | 7275 | 10.4% |
| o | 5568 | 7.9% |
| l | 4853 | 6.9% |
| c | 4604 | 6.6% |
| R | 4160 | 5.9% |
| a | 3819 | 5.4% |
| g | 3655 | 5.2% |
| n | 3649 | 5.2% |
| t | 3523 | 5.0% |
| Other values (21) | 18512 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 70249 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 10631 | |
| e | 7275 | 10.4% |
| o | 5568 | 7.9% |
| l | 4853 | 6.9% |
| c | 4604 | 6.6% |
| R | 4160 | 5.9% |
| a | 3819 | 5.4% |
| g | 3655 | 5.2% |
| n | 3649 | 5.2% |
| t | 3523 | 5.0% |
| Other values (21) | 18512 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 70249 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 10631 | |
| e | 7275 | 10.4% |
| o | 5568 | 7.9% |
| l | 4853 | 6.9% |
| c | 4604 | 6.6% |
| R | 4160 | 5.9% |
| a | 3819 | 5.4% |
| g | 3655 | 5.2% |
| n | 3649 | 5.2% |
| t | 3523 | 5.0% |
| Other values (21) | 18512 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 70249 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 10631 | |
| e | 7275 | 10.4% |
| o | 5568 | 7.9% |
| l | 4853 | 6.9% |
| c | 4604 | 6.6% |
| R | 4160 | 5.9% |
| a | 3819 | 5.4% |
| g | 3655 | 5.2% |
| n | 3649 | 5.2% |
| t | 3523 | 5.0% |
| Other values (21) | 18512 |
Arrest Date
Date
Missing 
| Distinct | 745 |
|---|---|
| Distinct (%) | 53.0% |
| Missing | 1849 |
| Missing (%) | 56.8% |
| Memory size | 25.6 KiB |
| Minimum | 2019-01-06 00:00:00 |
|---|---|
| Maximum | 2024-09-30 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Arrest Id
Text
Missing 
| Distinct | 1395 |
|---|---|
| Distinct (%) | 99.2% |
| Missing | 1849 |
| Missing (%) | 56.8% |
| Memory size | 137.5 KiB |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Unique
| Unique | 1387 ? |
|---|---|
| Unique (%) | 98.6% |
Sample
| 1st row | B33683676 |
|---|---|
| 2nd row | B34705870 |
| 3rd row | B34707656 |
| 4th row | K31675023 |
| 5th row | K31679592 |
| Value | Count | Frequency (%) |
| k35674657 | 3 | 0.2% |
| k35674659 | 3 | 0.2% |
| k35674656 | 3 | 0.2% |
| k34719303 | 2 | 0.1% |
| k34719306 | 2 | 0.1% |
| k34719305 | 2 | 0.1% |
| k35733591 | 2 | 0.1% |
| b31682806 | 2 | 0.1% |
| m36686302 | 1 | 0.1% |
| m36702494 | 1 | 0.1% |
| Other values (1385) | 1385 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 2236 | |
| 6 | 1715 | |
| 7 | 1314 | |
| 8 | 928 | |
| 5 | 919 | |
| 4 | 874 | 6.9% |
| 0 | 856 | 6.8% |
| 1 | 836 | 6.6% |
| 9 | 832 | 6.6% |
| 2 | 738 | 5.8% |
| Other values (5) | 1406 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 12654 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 3 | 2236 | |
| 6 | 1715 | |
| 7 | 1314 | |
| 8 | 928 | |
| 5 | 919 | |
| 4 | 874 | 6.9% |
| 0 | 856 | 6.8% |
| 1 | 836 | 6.6% |
| 9 | 832 | 6.6% |
| 2 | 738 | 5.8% |
| Other values (5) | 1406 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 12654 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 3 | 2236 | |
| 6 | 1715 | |
| 7 | 1314 | |
| 8 | 928 | |
| 5 | 919 | |
| 4 | 874 | 6.9% |
| 0 | 856 | 6.8% |
| 1 | 836 | 6.6% |
| 9 | 832 | 6.6% |
| 2 | 738 | 5.8% |
| Other values (5) | 1406 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 12654 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 3 | 2236 | |
| 6 | 1715 | |
| 7 | 1314 | |
| 8 | 928 | |
| 5 | 919 | |
| 4 | 874 | 6.9% |
| 0 | 856 | 6.8% |
| 1 | 836 | 6.6% |
| 9 | 832 | 6.6% |
| 2 | 738 | 5.8% |
| Other values (5) | 1406 |
Interactions
Correlations
| Bias Motive Description | Complaint Precinct Code | Complaint Year Number | County | Full Complaint ID | Law Code Category Description | Month Number | Offense Category | Offense Description | Patrol Borough Name | Unnamed: 0 | Unnamed: 0.1 | Unnamed: 0.2 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Bias Motive Description | 1.000 | 0.146 | 0.170 | 0.161 | 0.151 | 0.145 | 0.117 | 0.921 | 0.149 | 0.161 | 0.097 | 0.097 | 0.097 |
| Complaint Precinct Code | 0.146 | 1.000 | -0.020 | 0.861 | 0.160 | 0.054 | 0.018 | 0.100 | 0.091 | 0.793 | 0.055 | 0.055 | 0.055 |
| Complaint Year Number | 0.170 | -0.020 | 1.000 | 0.066 | 0.983 | 0.045 | -0.054 | 0.115 | 0.087 | 0.064 | 0.253 | 0.253 | 0.253 |
| County | 0.161 | 0.861 | 0.066 | 1.000 | 0.392 | 0.036 | 0.071 | 0.096 | 0.081 | 1.000 | 0.196 | 0.196 | 0.196 |
| Full Complaint ID | 0.151 | 0.160 | 0.983 | 0.392 | 1.000 | 0.040 | -0.049 | 0.106 | 0.076 | 0.315 | 0.260 | 0.260 | 0.260 |
| Law Code Category Description | 0.145 | 0.054 | 0.045 | 0.036 | 0.040 | 1.000 | 0.031 | 0.147 | 0.967 | 0.059 | 0.044 | 0.044 | 0.044 |
| Month Number | 0.117 | 0.018 | -0.054 | 0.071 | -0.049 | 0.031 | 1.000 | 0.091 | 0.053 | 0.062 | 0.023 | 0.023 | 0.023 |
| Offense Category | 0.921 | 0.100 | 0.115 | 0.096 | 0.106 | 0.147 | 0.091 | 1.000 | 0.210 | 0.097 | 0.082 | 0.082 | 0.082 |
| Offense Description | 0.149 | 0.091 | 0.087 | 0.081 | 0.076 | 0.967 | 0.053 | 0.210 | 1.000 | 0.099 | 0.126 | 0.126 | 0.126 |
| Patrol Borough Name | 0.161 | 0.793 | 0.064 | 1.000 | 0.315 | 0.059 | 0.062 | 0.097 | 0.099 | 1.000 | 0.152 | 0.152 | 0.152 |
| Unnamed: 0 | 0.097 | 0.055 | 0.253 | 0.196 | 0.260 | 0.044 | 0.023 | 0.082 | 0.126 | 0.152 | 1.000 | 1.000 | 1.000 |
| Unnamed: 0.1 | 0.097 | 0.055 | 0.253 | 0.196 | 0.260 | 0.044 | 0.023 | 0.082 | 0.126 | 0.152 | 1.000 | 1.000 | 1.000 |
| Unnamed: 0.2 | 0.097 | 0.055 | 0.253 | 0.196 | 0.260 | 0.044 | 0.023 | 0.082 | 0.126 | 0.152 | 1.000 | 1.000 | 1.000 |
Missing values
Sample
| Unnamed: 0.2 | Unnamed: 0.1 | Unnamed: 0 | Full Complaint ID | Complaint Year Number | Month Number | Record Create Date | Complaint Precinct Code | Patrol Borough Name | County | Law Code Category Description | Offense Description | PD Code Description | Bias Motive Description | Offense Category | Arrest Date | Arrest Id | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 0 | 0 | 202105012245817 | 2021 | 5 | 05/01/2021 | 50 | PATROL BORO BRONX | BRONX | FELONY | BURGLARY | BURGLARY,UNCLASSIFIED,NIGHT | ANTI-JEWISH | Religion/Religious Practice | 05/01/2021 | B33683676 |
| 1 | 1 | 1 | 1 | 202105012668317 | 2021 | 12 | 12/28/2021 | 50 | PATROL BORO BRONX | BRONX | FELONY | MISCELLANEOUS PENAL LAW | AGGRAVATED HARASSMENT 1 | ANTI-JEWISH | Religion/Religious Practice | 09/28/2022 | B34705870 |
| 2 | 2 | 2 | 2 | 202204912792117 | 2022 | 10 | 10/11/2022 | 49 | PATROL BORO BRONX | BRONX | FELONY | FELONY ASSAULT | ASSAULT 2,1,UNCLASSIFIED | ANTI-MALE HOMOSEXUAL (GAY) | Sexual Orientation | 10/11/2022 | B34707656 |
| 3 | 3 | 3 | 3 | 201906112101017 | 2019 | 1 | 01/15/2019 | 61 | PATROL BORO BKLYN SOUTH | KINGS | FELONY | MURDER & NON-NEGL. MANSLAUGHTE | MURDER,UNCLASSIFIED | ANTI-ASIAN | Race/Color | 01/16/2019 | K31675023 |
| 4 | 4 | 4 | 4 | 201907112148117 | 2019 | 2 | 02/08/2019 | 71 | PATROL BORO BKLYN SOUTH | KINGS | MISDEMEANOR | OFF. AGNST PUB ORD SENSBLTY & | AGGRAVATED HARASSMENT 2 | ANTI-JEWISH | Religion/Religious Practice | 02/08/2019 | K31679592 |
| 5 | 5 | 5 | 5 | 201909412188717 | 2019 | 4 | 04/06/2019 | 94 | PATROL BORO BKLYN NORTH | KINGS | FELONY | MISCELLANEOUS PENAL LAW | AGGRAVATED HARASSMENT 1 | ANTI-JEWISH | Religion/Religious Practice | 04/05/2019 | K31690190 |
| 6 | 6 | 6 | 6 | 201907012248417 | 2019 | 3 | 03/17/2019 | 70 | PATROL BORO BKLYN SOUTH | KINGS | MISDEMEANOR | ASSAULT 3 & RELATED OFFENSES | ASSAULT 3 | ANTI-MUSLIM | Religion/Religious Practice | 04/07/2019 | K31690422 |
| 7 | 7 | 7 | 7 | 201907912598517 | 2019 | 7 | 07/28/2019 | 79 | PATROL BORO BKLYN NORTH | KINGS | FELONY | ROBBERY | ROBBERY,PERSONAL ELECTRONIC DEVICE | ANTI-MALE HOMOSEXUAL (GAY) | Sexual Orientation | 07/28/2019 | K31710604 |
| 8 | 8 | 8 | 8 | 201907912598517 | 2019 | 7 | 07/28/2019 | 79 | PATROL BORO BKLYN NORTH | KINGS | FELONY | ROBBERY | ROBBERY,PERSONAL ELECTRONIC DEVICE | ANTI-MALE HOMOSEXUAL (GAY) | Sexual Orientation | 07/28/2019 | K31710607 |
| 9 | 9 | 9 | 9 | 202007012371917 | 2020 | 5 | 05/12/2020 | 70 | PATROL BORO BKLYN SOUTH | KINGS | FELONY | MISCELLANEOUS PENAL LAW | AGGRAVATED HARASSMENT 1 | ANTI-JEWISH | Religion/Religious Practice | 05/12/2020 | K32688959 |
| Unnamed: 0.2 | Unnamed: 0.1 | Unnamed: 0 | Full Complaint ID | Complaint Year Number | Month Number | Record Create Date | Complaint Precinct Code | Patrol Borough Name | County | Law Code Category Description | Offense Description | PD Code Description | Bias Motive Description | Offense Category | Arrest Date | Arrest Id | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3245 | 3245 | 3245 | 3245 | 202400112523317 | 2024 | 6 | 06/06/2024 | 1 | PATROL BORO MAN SOUTH | NEW YORK | VIOLATION | HARRASSMENT 2 | HARASSMENT,SUBD 3,4,5 | ANTI-JEWISH | Religion/Religious Practice | NaN | NaN |
| 3246 | 3246 | 3246 | 3246 | 202401312664717 | 2024 | 7 | 07/30/2024 | 13 | PATROL BORO MAN SOUTH | NEW YORK | MISDEMEANOR | CRIMINAL MISCHIEF & RELATED OF | CRIMINAL MISCHIEF 4TH, GRAFFIT | ANTI-JEWISH | Religion/Religious Practice | NaN | NaN |
| 3247 | 3247 | 3247 | 3247 | 202401712125817 | 2024 | 6 | 02/07/2024 | 17 | PATROL BORO MAN SOUTH | NEW YORK | MISDEMEANOR | OFF. AGNST PUB ORD SENSBLTY & | AGGRAVATED HARASSMENT 2 | ANTI-TRANSGENDER | Gender | NaN | NaN |
| 3248 | 3248 | 3248 | 3248 | 202402412209317 | 2024 | 3 | 03/31/2024 | 24 | PATROL BORO MAN NORTH | NEW YORK | FELONY | ROBBERY | ROBBERY,PUBLIC PLACE INSIDE | ANTI-OTHER ETHNICITY | Ethnicity/National Origin/Ancestry | NaN | NaN |
| 3249 | 3249 | 3249 | 3249 | 202402612174817 | 2024 | 4 | 04/04/2024 | 26 | PATROL BORO MAN NORTH | NEW YORK | FELONY | MISCELLANEOUS PENAL LAW | AGGRAVATED HARASSMENT 1 | ANTI-JEWISH | Religion/Religious Practice | NaN | NaN |
| 3250 | 3250 | 3250 | 3250 | 202406612371517 | 2024 | 5 | 06/06/2024 | 66 | PATROL BORO BKLYN SOUTH | KINGS | FELONY | MISCELLANEOUS PENAL LAW | AGGRAVATED HARASSMENT 1 | ANTI-JEWISH | Religion/Religious Practice | NaN | NaN |
| 3251 | 3251 | 3251 | 3251 | 202406812217617 | 2024 | 3 | 03/19/2024 | 68 | PATROL BORO BKLYN SOUTH | KINGS | FELONY | CRIMINAL MISCHIEF & RELATED OF | CRIMINAL MIS 2 & 3 | ANTI-JEWISH | Religion/Religious Practice | NaN | NaN |
| 3252 | 3252 | 3252 | 3252 | 202408412587417 | 2024 | 7 | 07/30/2024 | 84 | PATROL BORO BKLYN NORTH | KINGS | FELONY | FELONY ASSAULT | ASSAULT 2,1,UNCLASSIFIED | ANTI-MALE HOMOSEXUAL (GAY) | Sexual Orientation | NaN | NaN |
| 3253 | 3253 | 3253 | 3253 | 202410412379817 | 2024 | 5 | 05/10/2024 | 104 | PATROL BORO QUEENS NORTH | QUEENS | FELONY | MISCELLANEOUS PENAL LAW | AGGRAVATED HARASSMENT 1 | ANTI-MUSLIM | Religion/Religious Practice | NaN | NaN |
| 3254 | 3254 | 3254 | 3254 | 202410712566517 | 2024 | 7 | 07/21/2024 | 107 | PATROL BORO QUEENS SOUTH | QUEENS | FELONY | MISCELLANEOUS PENAL LAW | AGGRAVATED HARASSMENT 1 | ANTI-JEWISH | Religion/Religious Practice | NaN | NaN |